/*
Navicat SQL Server Data Transfer

Source Server         :
Source Server Version : 105000
Source Host           : 192.168.1.156:1433
Source Database       : cdny
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 105000
File Encoding         : 65001

Date: 2018-07-31 20:36:09
*/


-- ----------------------------
-- Table structure for SYS_FUNC
-- ----------------------------
DROP TABLE [dbo].[SYS_FUNC]
GO
CREATE TABLE [dbo].[SYS_FUNC] (
[ID] varchar(50) NOT NULL ,
[FUNC_CODE] varchar(100) NULL ,
[NAME] varchar(100) NULL ,
[FUNC_TYPE] varchar(20) NULL ,
[ISOPEN] varchar(20) NULL ,
[OPENDATE] date NULL ,
[FUNC_URL] varchar(200) NULL ,
[FUNC_DESC] varchar(600) NULL ,
[PID] varchar(50) NULL ,
[FUNC_LEVEL] int NULL ,
[FUNC_SEQ] int NULL ,
[ISLEAF] varchar(20) NULL ,
[ISPARENT] varchar(20) NULL ,
[CREATEUSER] varchar(100) NULL ,
[CREATETIME] date NULL ,
[BZ] varchar(800) NULL ,
[VERSION] int NULL ,
[DELETED] varchar(20) NULL ,
[CLASSFIELD] varchar(100) NULL ,
[OPEN] int NULL ,
[SITEID] varchar(20) NULL ,
[GROUPTYPE] varchar(10) NULL ,
[SERVICEADDR] varchar(300) NULL ,
[SELECTLAYER] varchar(300) NULL ,
[TABLENAME] varchar(100) NULL 
)


GO

-- ----------------------------
-- Records of SYS_FUNC
-- ----------------------------
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'1', null, N'菜单管理', null, N'1', null, null, null, N'0', null, null, N'0', N'1', null, null, null, null, null, null, N'1', N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'4028198163633ca301636394362d0002', null, N'数字地图', N'1', N'0', null, N'/SZMap.jsp', null, N'4028810260d4809b0160d4be9e160000', null, N'1', N'0', N'1', null, null, null, N'3', null, N'glyphicon glyphicon-globe', null, N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'4028198163633ca30163639d19260003', null, N'土壤检测', N'1', N'0', null, N'/TRDetection.jsp', null, N'4028810260d4809b0160d4be9e160000', null, N'4', N'0', N'1', null, null, null, N'3', null, N'glyphicon glyphicon-road', null, N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'4028198163633ca30163639e467e0004', null, N'气候管理', N'1', N'0', null, N'/wearth/wearth.jsp', null, N'4028810260d4809b0160d4be9e160000', null, N'5', N'0', N'1', null, null, null, N'3', null, N'glyphicon glyphicon-leaf', null, N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'4028198163633ca30163639f227b0005', null, N'基础管理', N'1', N'0', null, N'/', null, N'4028810260d4809b0160d4be9e160000', null, N'7', N'0', N'1', null, null, null, N'3', null, N'glyphicon glyphicon-th-list', null, N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'4028198163633ca30163639f9d180006', null, N'人员库管理', N'2', N'0', null, N'/Personnel.jsp', null, N'4028198163633ca30163639f227b0005', null, N'1', N'0', N'1', null, null, null, N'1', N'0', null, null, N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'4028198163633ca30163639fee760007', null, N'作物库管理', N'2', N'0', null, N'/Plant.jsp', null, N'4028198163633ca30163639f227b0005', null, N'2', N'0', N'1', null, null, null, N'1', N'0', null, null, N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'4028198163633ca3016363a047860008', null, N'农资库管理', N'2', N'0', null, N'/Resources.jsp', null, N'4028198163633ca30163639f227b0005', null, N'3', N'0', N'1', null, null, null, N'1', N'0', null, null, N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'4028198163633ca3016363a0a1bf0009', null, N'设备库管理', N'2', N'0', null, N'/Work.jsp', null, N'4028198163633ca30163639f227b0005', null, N'4', N'0', N'1', null, null, null, N'2', null, null, null, N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'4028198163633ca3016363a289e8000a', null, N'服务管理', N'2', N'0', null, N'/system/mapServer.jsp', null, N'402881cd5fbd2daf015fbea277a60000', null, N'4', N'0', N'1', null, null, null, N'2', null, null, null, N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'4028810260d4809b0160d4be9e160000', null, N'智慧农业云平台', N'0', N'0', null, N'/', null, N'1', null, N'1', N'0', N'1', N'lsf', null, null, N'4', null, null, null, N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'402881a25fd20311015fd20a6fdb0004', N'RoleAdmin_New', N'新建', N'3', N'1', null, N'role_add', N'新建', N'402881cd5fbd2daf015fbea682710003', N'4', N'1', N'0', N'1', N'管理员', null, N'角色管理模块 新建角色功能', N'5', null, null, N'1', N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'402881cd5fbd2daf015fbea277a60000', null, N'系统管理', N'1', N'0', null, N'/', null, N'4028810260d4809b0160d4be9e160000', null, N'8', N'0', N'1', N'管理员', null, N'系统管理模块', N'11', null, N'glyphicon glyphicon-cog', N'1', N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'402881cd5fbd2daf015fbea419fc0001', null, N'用户管理', N'2', N'0', null, N'/system/userControl.jsp', null, N'402881cd5fbd2daf015fbea277a60000', null, N'1', N'0', N'1', null, null, N'111', N'2', null, null, N'1', N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'402881cd5fbd2daf015fbea682710003', null, N'角色管理', N'2', N'0', null, N'/system/roleManage.jsp', null, N'402881cd5fbd2daf015fbea277a60000', null, N'2', N'0', N'1', N'1', null, N'角色管理功能页面', N'6', null, null, N'1', N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'402881cd5fbd2daf015fbea713d30004', null, N'种植管理', N'1', N'0', null, N'/ZZManage.jsp', null, N'4028810260d4809b0160d4be9e160000', null, N'3', N'0', N'1', null, null, null, N'12', null, N'glyphicon glyphicon-tree-deciduous', N'1', N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'402881cd5fc2b709015fc2d6b7ea0000', null, N'系统名称', N'0', N'0', null, N'/images/title_white.png', null, N'4028810260d4809b0160d4be9e160000', null, N'9', N'0', N'1', null, null, null, N'9', null, null, N'1', N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'402881cd5fc2b709015fc2ff1ca40006', null, N'区划管理', N'1', N'0', null, N'/index.jsp', null, N'4028810260d4809b0160d4be9e160000', null, N'2', N'0', N'1', N'管理员', null, N'首页', N'9', null, N'glyphicon glyphicon-dashboard', N'1', N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'402881cd5fc2b709015fc3716f6c001a', null, N'菜单管理', N'2', N'0', null, N'/system/menu.jsp', null, N'402881cd5fbd2daf015fbea277a60000', null, N'3', N'0', N'1', null, null, null, N'5', null, null, N'1', N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'402881cd5fc2b709015fc371bd68001b', null, N'字典管理', N'2', N'0', null, N'/system/dictionaries.jsp', null, N'402881cd5fbd2daf015fbea277a60000', null, N'5', N'0', N'1', null, null, null, N'3', null, null, N'1', N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'402881cd5fdd05af015fdd397bdf001f', N'RoleAdmin_Edit', N'编辑', N'3', N'1', null, N'role_update', N'编辑', N'402881cd5fbd2daf015fbea682710003', N'4', N'2', N'0', N'1', N'管理员', null, N'角色管理 编辑功能', N'5', null, null, N'1', N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'402881cd5fdd05af015fdd3a99470020', N'RoleAdmin_Delete', N'删除', N'3', N'1', null, N'role_delete', N'角色删除', N'402881cd5fbd2daf015fbea682710003', N'4', N'3', N'0', N'1', N'管理员', null, N'角色管理 删除', N'3', null, null, N'1', N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'402881cd5fdd05af015fdd3bba8f0021', N'RoleAdmin_Right', N'角色授权', N'3', N'1', null, N'role_authorize', N'角色授权', N'402881cd5fbd2daf015fbea682710003', N'4', N'4', N'0', N'1', N'管理员', null, N'角色管理 授权', N'8', null, null, N'1', N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'402881cd5fdd05af015fdd3e1f830022', N'MenuAdmin_New', N'新建', N'3', N'1', null, N'fun_add', null, N'402881cd5fc2b709015fc3716f6c001a', N'4', N'1', N'0', N'1', N'管理员', null, N'菜单管理 新建', N'2', null, null, N'1', N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'402881cd5fdd05af015fdd42144d0023', N'MenuAdmin_Delete', N'删除', N'3', N'1', null, N'fun_delete', null, N'402881cd5fc2b709015fc3716f6c001a', N'4', N'2', N'0', N'1', N'管理员', null, N'删除菜单项', N'2', null, null, N'1', N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'402881cd5fdd05af015fdd43cbdc0025', N'MenuAdmin_Save', N'保存', N'3', N'1', null, N'fun_save', N'保存', N'402881cd5fc2b709015fc3716f6c001a', N'4', N'4', N'0', N'1', N'管理员', null, N'保存', N'2', null, null, null, N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'402881cd5fdd05af015fdd464dc00027', N'RoleAdmin_Query', N'查询', N'3', N'1', null, N'role_select', N'查询（包含高级查询）', N'402881cd5fbd2daf015fbea682710003', N'4', N'5', N'0', N'1', N'管理员', null, N'查询（包含高级查询）', N'2', null, null, null, N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'402881cd5fdd05af015fdd474e910028', null, N'新建', N'3', N'0', null, N'dict_add', null, N'402881cd5fc2b709015fc371bd68001b', null, N'1', N'0', N'1', N'管理员', null, N'新建字典', N'3', null, null, null, N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'402881cd5fdd05af015fdd47f76c0029', null, N'编辑', N'3', N'0', null, N'dict_edit', null, N'402881cd5fc2b709015fc371bd68001b', null, N'2', N'0', N'1', N'管理员', null, N'编辑字典', N'3', null, null, null, N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'402881cd5fdd05af015fdd490c71002a', null, N'删除', N'3', N'0', null, N'dict_delete', null, N'402881cd5fc2b709015fc371bd68001b', null, N'3', N'0', N'1', N'管理员', null, N'删除字典', N'3', null, null, null, N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'402881cd5fdd05af015fdd4bc895002c', N'DictAdmin_Save', N'保存', N'3', N'1', null, N'dict_save', N'保存', N'402881cd5fc2b709015fc371bd68001b', N'4', N'5', N'0', N'1', N'管理员', null, N'保存', N'2', null, null, null, N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'402881cd5fdd05af015fdd4d3dc7002d', N'UserAdmin_New', N'新建', N'3', N'1', null, N'user_add', N'新建', N'402881cd5fbd2daf015fbea419fc0001', N'4', N'1', N'0', N'1', N'管理员', null, N'新建', N'2', null, null, null, N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'402881cd5fdd05af015fdd4f16db002e', N'UserAdmin_Delete', N'删除', N'3', N'1', null, N'user_delete', N'删除', N'402881cd5fbd2daf015fbea419fc0001', N'4', N'2', N'0', N'1', N'管理员', null, N'删除', N'3', null, null, null, N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'402881cd6005a026016005d45011005c', N'UserAdmin_revamp', N'修改', N'3', N'1', null, N'user_revamp', null, N'402881cd5fbd2daf015fbea419fc0001', null, N'3', N'0', N'1', N'cyq', null, null, N'1', N'0', null, N'1', N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'402881cd6005a026016005db7589005d', N'UserAdmin_Query', N'查询', N'3', N'1', null, N'user_select', null, N'402881cd5fbd2daf015fbea419fc0001', null, N'4', N'0', N'1', N'cyq', null, null, N'1', N'0', null, N'1', N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'402881cd609fe01b0160a008c75c0001', N'UserAdmin_Right', N'用户授权', N'3', N'1', null, N'user_authorize', null, N'402881cd5fbd2daf015fbea419fc0001', null, N'6', N'0', N'1', N'cyq', null, null, N'2', null, null, null, N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'4028da63636b78bf01636c8cbebf0003', null, N'天空地遥感反演', N'1', N'0', null, N'/', null, N'4028810260d4809b0160d4be9e160000', null, N'6', N'0', N'1', null, null, null, N'2', null, N'glyphicon glyphicon-retweet', null, N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'4028da63636b78bf01636c901c2a0004', null, N'长势监测', N'2', N'0', null, N'/fanyan/one.jsp', null, N'4028da63636b78bf01636c8cbebf0003', null, N'1', N'0', N'1', null, null, null, N'6', null, null, null, N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'4028da63636b78bf01636c91046e0005', null, N'成熟度监测', N'2', N'0', null, N'/fanyan/two.jsp', null, N'4028da63636b78bf01636c8cbebf0003', null, N'2', N'0', N'1', null, null, null, N'2', null, null, null, N'1', null, null, null, null)
GO
GO
INSERT INTO [dbo].[SYS_FUNC] ([ID], [FUNC_CODE], [NAME], [FUNC_TYPE], [ISOPEN], [OPENDATE], [FUNC_URL], [FUNC_DESC], [PID], [FUNC_LEVEL], [FUNC_SEQ], [ISLEAF], [ISPARENT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [CLASSFIELD], [OPEN], [SITEID], [GROUPTYPE], [SERVICEADDR], [SELECTLAYER], [TABLENAME]) VALUES (N'4028da63636b78bf01636c917ec50006', null, N'品质检测', N'2', N'0', null, N'/fanyan/three.jsp', null, N'4028da63636b78bf01636c8cbebf0003', null, N'3', N'0', N'1', null, null, null, N'2', null, null, null, N'1', null, null, null, null)
GO
GO

-- ----------------------------
-- Table structure for SYS_FUNC_ROLE_R
-- ----------------------------
DROP TABLE [dbo].[SYS_FUNC_ROLE_R]
GO
CREATE TABLE [dbo].[SYS_FUNC_ROLE_R] (
[FUNC_ID] varchar(50) NULL ,
[FUNC_CODE] varchar(100) NULL ,
[FUNC_NAME] varchar(200) NULL ,
[ROLE_ID] varchar(50) NULL ,
[ROLE_CODE] varchar(100) NULL ,
[ROLE_NAME] varchar(200) NULL ,
[AUTHUSER] varchar(200) NULL ,
[AUTHTIME] datetime NULL ,
[DELETED] varchar(20) NULL ,
[ID] varchar(50) NOT NULL ,
[VERSION] int NULL 
)


GO

-- ----------------------------
-- Records of SYS_FUNC_ROLE_R
-- ----------------------------
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fbd2daf015fbea713d30004', null, null, N'615c89f44a774873b48e7f004029ca0d', null, null, null, N'2018-05-15 09:09:52.750', N'0', N'402819816363a69a016363b4f177002a', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'4028198163633ca30163639f227b0005', null, null, N'615c89f44a774873b48e7f004029ca0d', null, null, null, N'2018-05-15 09:09:52.750', N'0', N'402819816363a69a016363b4f18f002b', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'4028198163633ca30163639f9d180006', null, null, N'615c89f44a774873b48e7f004029ca0d', null, null, null, N'2018-05-15 09:09:52.750', N'0', N'402819816363a69a016363b4f1a9002c', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'4028198163633ca30163639fee760007', null, null, N'615c89f44a774873b48e7f004029ca0d', null, null, null, N'2018-05-15 09:09:52.750', N'0', N'402819816363a69a016363b4f1bf002d', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'4028198163633ca3016363a047860008', null, null, N'615c89f44a774873b48e7f004029ca0d', null, null, null, N'2018-05-15 09:09:52.750', N'0', N'402819816363a69a016363b4f1d6002e', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'4028198163633ca3016363a0a1bf0009', null, null, N'615c89f44a774873b48e7f004029ca0d', null, null, null, N'2018-05-15 09:09:52.750', N'0', N'402819816363a69a016363b4f1eb002f', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fc2b709015fc2d6b7ea0000', null, null, N'615c89f44a774873b48e7f004029ca0d', null, null, null, N'2018-05-15 09:09:52.750', N'0', N'402819816363a69a016363b4f2000030', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fbd2daf015fbea277a60000', null, null, N'25ddf321-c039-40d3-9b12-ab781572a822', null, null, null, N'2018-05-18 05:18:18.840', N'0', N'40282d816370a41801637254045d0038', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fbd2daf015fbea419fc0001', null, null, N'25ddf321-c039-40d3-9b12-ab781572a822', null, null, null, N'2018-05-18 05:18:18.840', N'0', N'40282d816370a41801637254046e0039', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fdd05af015fdd4d3dc7002d', null, null, N'25ddf321-c039-40d3-9b12-ab781572a822', null, null, null, N'2018-05-18 05:18:18.840', N'0', N'40282d816370a418016372540481003a', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fbd2daf015fbea682710003', null, null, N'25ddf321-c039-40d3-9b12-ab781572a822', null, null, null, N'2018-05-18 05:18:18.840', N'0', N'40282d816370a418016372540493003b', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881a25fd20311015fd20a6fdb0004', null, null, N'25ddf321-c039-40d3-9b12-ab781572a822', null, null, null, N'2018-05-18 05:18:18.840', N'0', N'40282d816370a4180163725404a6003c', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fdd05af015fdd397bdf001f', null, null, N'25ddf321-c039-40d3-9b12-ab781572a822', null, null, null, N'2018-05-18 05:18:18.840', N'0', N'40282d816370a4180163725404b6003d', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fdd05af015fdd3a99470020', null, null, N'25ddf321-c039-40d3-9b12-ab781572a822', null, null, null, N'2018-05-18 05:18:18.840', N'0', N'40282d816370a4180163725404c5003e', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fdd05af015fdd464dc00027', null, null, N'25ddf321-c039-40d3-9b12-ab781572a822', null, null, null, N'2018-05-18 05:18:18.840', N'0', N'40282d816370a4180163725404d5003f', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fc2b709015fc3716f6c001a', null, null, N'25ddf321-c039-40d3-9b12-ab781572a822', null, null, null, N'2018-05-18 05:18:18.840', N'0', N'40282d816370a4180163725404e40040', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fdd05af015fdd3e1f830022', null, null, N'25ddf321-c039-40d3-9b12-ab781572a822', null, null, null, N'2018-05-18 05:18:18.840', N'0', N'40282d816370a4180163725404f60041', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'4028198163633ca3016363a289e8000a', null, null, N'25ddf321-c039-40d3-9b12-ab781572a822', null, null, null, N'2018-05-18 05:18:18.840', N'0', N'40282d816370a4180163725405080042', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fc2b709015fc371bd68001b', null, null, N'25ddf321-c039-40d3-9b12-ab781572a822', null, null, null, N'2018-05-18 05:18:18.840', N'0', N'40282d816370a41801637254051b0043', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fdd05af015fdd474e910028', null, null, N'25ddf321-c039-40d3-9b12-ab781572a822', null, null, null, N'2018-05-18 05:18:18.840', N'0', N'40282d816370a41801637254052c0044', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fdd05af015fdd47f76c0029', null, null, N'25ddf321-c039-40d3-9b12-ab781572a822', null, null, null, N'2018-05-18 05:18:18.840', N'0', N'40282d816370a4180163725405420045', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fdd05af015fdd490c71002a', null, null, N'25ddf321-c039-40d3-9b12-ab781572a822', null, null, null, N'2018-05-18 05:18:18.840', N'0', N'40282d816370a4180163725405580046', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fdd05af015fdd4bc895002c', null, null, N'25ddf321-c039-40d3-9b12-ab781572a822', null, null, null, N'2018-05-18 05:18:18.840', N'0', N'40282d816370a4180163725405710047', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'4028810260d4809b0160d4be9e160000', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921ebf0007', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'4028198163633ca301636394362d0002', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921ec90008', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fc2b709015fc2ff1ca40006', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921ed20009', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fbd2daf015fbea713d30004', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921ed7000a', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'4028198163633ca30163639d19260003', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921edc000b', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'4028198163633ca30163639e467e0004', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921ee1000c', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'4028da63636b78bf01636c8cbebf0003', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921ee6000d', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'4028da63636b78bf01636c901c2a0004', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921eeb000e', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'4028da63636b78bf01636c91046e0005', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921eef000f', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'4028da63636b78bf01636c917ec50006', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921ef30010', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'4028198163633ca30163639f227b0005', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921ef80011', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'4028198163633ca30163639f9d180006', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921efc0012', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'4028198163633ca30163639fee760007', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921eff0013', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'4028198163633ca3016363a047860008', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f020014', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'4028198163633ca3016363a0a1bf0009', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f050015', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fbd2daf015fbea277a60000', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f080016', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fbd2daf015fbea419fc0001', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f0b0017', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fdd05af015fdd4d3dc7002d', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f0e0018', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fdd05af015fdd4f16db002e', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f110019', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd6005a026016005d45011005c', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f15001a', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd6005a026016005db7589005d', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f18001b', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fdd05af015fdd4ff988002f', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f1b001c', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd609fe01b0160a008c75c0001', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f1e001d', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fbd2daf015fbea682710003', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f21001e', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881a25fd20311015fd20a6fdb0004', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f24001f', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fdd05af015fdd397bdf001f', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f270020', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fdd05af015fdd3a99470020', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f2a0021', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fdd05af015fdd3bba8f0021', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f2d0022', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fdd05af015fdd464dc00027', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f300023', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fc2b709015fc3716f6c001a', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f330024', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fdd05af015fdd3e1f830022', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f360025', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fdd05af015fdd42144d0023', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f390026', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fdd05af015fdd42cd710024', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f3c0027', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fdd05af015fdd43cbdc0025', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f3f0028', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fdd05af015fdd44cb640026', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f420029', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'4028198163633ca3016363a289e8000a', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f45002a', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fc2b709015fc371bd68001b', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f48002b', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fdd05af015fdd474e910028', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f4b002c', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fdd05af015fdd47f76c0029', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f4e002d', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fdd05af015fdd490c71002a', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f51002e', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fdd05af015fdd4aa169002b', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f54002f', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fdd05af015fdd4bc895002c', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f570030', N'1')
GO
GO
INSERT INTO [dbo].[SYS_FUNC_ROLE_R] ([FUNC_ID], [FUNC_CODE], [FUNC_NAME], [ROLE_ID], [ROLE_CODE], [ROLE_NAME], [AUTHUSER], [AUTHTIME], [DELETED], [ID], [VERSION]) VALUES (N'402881cd5fc2b709015fc2d6b7ea0000', null, null, N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', null, null, null, N'2018-05-17 13:28:25.530', N'0', N'4028da63636b78bf01636c921f5a0031', N'1')
GO
GO

-- ----------------------------
-- Table structure for SYS_RES_CONTENT
-- ----------------------------
DROP TABLE [dbo].[SYS_RES_CONTENT]
GO
CREATE TABLE [dbo].[SYS_RES_CONTENT] (
[ID] varchar(50) NOT NULL ,
[CODE] varchar(50) NULL ,
[NAME] varchar(100) NULL ,
[SJLX] varchar(20) NULL ,
[MLTYPE] varchar(20) NULL ,
[PID] varchar(50) NULL ,
[SSML] varchar(50) NULL ,
[SORT] int NULL ,
[CREATEUSER] varchar(100) NULL ,
[CREATETIME] datetime NULL ,
[BZ] varchar(600) NULL ,
[VERSION] int NULL ,
[DELETED] varchar(20) NULL ,
[HASINFO] varchar(20) NULL ,
[ICON_P] varchar(100) NULL ,
[URL] varchar(100) NULL 
)


GO

-- ----------------------------
-- Records of SYS_RES_CONTENT
-- ----------------------------
INSERT INTO [dbo].[SYS_RES_CONTENT] ([ID], [CODE], [NAME], [SJLX], [MLTYPE], [PID], [SSML], [SORT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [HASINFO], [ICON_P], [URL]) VALUES (N'2', null, N'地图服务', N'2', N'1', N'0', null, null, null, null, null, null, null, null, N'/home/image/recourse/dtfw.png', N'view/dataMart/shadow.jsp')
GO
GO
INSERT INTO [dbo].[SYS_RES_CONTENT] ([ID], [CODE], [NAME], [SJLX], [MLTYPE], [PID], [SSML], [SORT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [HASINFO], [ICON_P], [URL]) VALUES (N'4028198163684b7a0163685105b70004', null, N'服务1', N'2', N'0', N'40283f816366ec35016368280e530006', N'ArcGIS切片服务', N'1', null, N'2018-05-16 06:38:50.413', N'', N'1', N'0', N'0', null, null)
GO
GO
INSERT INTO [dbo].[SYS_RES_CONTENT] ([ID], [CODE], [NAME], [SJLX], [MLTYPE], [PID], [SSML], [SORT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [HASINFO], [ICON_P], [URL]) VALUES (N'4028198163684b7a0163685136120005', null, N'服务2', N'2', N'0', N'40283f816366ec35016368280e530006', N'ArcGIS切片服务', N'2', null, N'2018-05-16 06:39:02.793', N'', N'1', N'0', N'0', null, null)
GO
GO
INSERT INTO [dbo].[SYS_RES_CONTENT] ([ID], [CODE], [NAME], [SJLX], [MLTYPE], [PID], [SSML], [SORT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [HASINFO], [ICON_P], [URL]) VALUES (N'40283f816366ec35016368280e530006', null, N'ArcGIS切片服务', N'2', N'1', N'2', N'地图服务', N'1', null, N'2018-05-16 05:54:05.583', N'', N'1', N'0', N'0', null, null)
GO
GO
INSERT INTO [dbo].[SYS_RES_CONTENT] ([ID], [CODE], [NAME], [SJLX], [MLTYPE], [PID], [SSML], [SORT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [HASINFO], [ICON_P], [URL]) VALUES (N'402881376486c5e50164874f63be0001', null, N'测试', N'2', N'1', N'2', N'地图服务', N'2', null, N'2018-07-11 11:08:04.407', N'', N'1', N'0', N'0', null, null)
GO
GO
INSERT INTO [dbo].[SYS_RES_CONTENT] ([ID], [CODE], [NAME], [SJLX], [MLTYPE], [PID], [SSML], [SORT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [HASINFO], [ICON_P], [URL]) VALUES (N'402881576467fb48016468385f740000', null, N'abc', N'2', N'0', N'40283f816366ec35016368280e530006', N'ArcGIS切片服务', N'1', null, N'2018-07-05 10:14:42.287', N'', N'1', N'0', N'0', null, null)
GO
GO
INSERT INTO [dbo].[SYS_RES_CONTENT] ([ID], [CODE], [NAME], [SJLX], [MLTYPE], [PID], [SSML], [SORT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [HASINFO], [ICON_P], [URL]) VALUES (N'4028819064edf9de0164eedf7d080000', null, N'服务3', N'2', N'0', N'40283f816366ec35016368280e530006', N'ArcGIS切片服务', N'3', null, N'2018-07-31 13:46:21.287', N'', N'1', N'0', N'0', null, null)
GO
GO
INSERT INTO [dbo].[SYS_RES_CONTENT] ([ID], [CODE], [NAME], [SJLX], [MLTYPE], [PID], [SSML], [SORT], [CREATEUSER], [CREATETIME], [BZ], [VERSION], [DELETED], [HASINFO], [ICON_P], [URL]) VALUES (N'4028da6363764cca016376643bd90001', null, N'q', N'2', N'0', N'40283f816366ec35016368280e530006', N'ArcGIS切片服务', N'3', null, N'2018-05-19 11:14:30.483', N'', N'1', N'0', N'0', null, null)
GO
GO

-- ----------------------------
-- Table structure for SYS_RES_INFO
-- ----------------------------
DROP TABLE [dbo].[SYS_RES_INFO]
GO
CREATE TABLE [dbo].[SYS_RES_INFO] (
[ID] varchar(50) NOT NULL ,
[NODEID] varchar(300) NULL ,
[NAME] varchar(300) NULL ,
[MLTYPE] varchar(50) NULL ,
[DATYPE] varchar(50) NULL ,
[URL] varchar(1000) NULL ,
[DADESC] varchar(2000) NULL ,
[FAMAT] varchar(50) NULL ,
[DASIZE] varchar(500) NULL ,
[SSMLMC] varchar(1000) NULL ,
[SSMLID] varchar(100) NULL ,
[SLT] varchar(2000) NULL ,
[KEYWORD] varchar(50) NULL ,
[ABSTRACT] varchar(1000) NULL ,
[SCOPE] varchar(50) NULL ,
[XXFL] varchar(50) NULL ,
[ZTFL] varchar(100) NULL ,
[CKZBX] varchar(2000) NULL ,
[GXZQ] varchar(50) NULL ,
[ZCR] varchar(300) NULL ,
[METANAME] varchar(100) NULL ,
[ALIANAME] varchar(100) NULL ,
[METADESC] varchar(100) NULL ,
[DWMC] varchar(100) NULL ,
[DWDZ] varchar(100) NULL ,
[LXRMC] varchar(100) NULL ,
[EMAIL] varchar(50) NULL ,
[WEBSITE] varchar(50) NULL ,
[LXDH] varchar(50) NULL ,
[FBRQ] datetime NULL ,
[MINX] varchar(50) NULL ,
[MINY] varchar(50) NULL ,
[MAXX] varchar(50) NULL ,
[MAXY] varchar(50) NULL ,
[WKID] varchar(50) NULL ,
[WKT] varchar(50) NULL ,
[REQUESTMODE] varchar(50) NULL ,
[SCCS] int NULL ,
[LLCS] int NULL ,
[SQCS] int NULL ,
[VERSION] int NULL DEFAULT ((1)) ,
[DELETED] int NULL DEFAULT ((0)) ,
[CREATETIME] datetime NULL ,
[PIDNAME] varchar(100) NULL ,
[TYPE] varchar(10) NULL ,
[PREFIX] varchar(100) NULL ,
[ADDRESS] varchar(100) NULL ,
[ZYBM] varchar(100) NULL ,
[CROSS_TYPE] int NULL ,
[CSJL] varchar(200) NULL ,
[APPKEY] varchar(200) NULL ,
[LUURL] varchar(200) NULL ,
[METATYPE] varchar(1) NULL ,
[FZ] varchar(200) NULL 
)


GO

-- ----------------------------
-- Records of SYS_RES_INFO
-- ----------------------------
INSERT INTO [dbo].[SYS_RES_INFO] ([ID], [NODEID], [NAME], [MLTYPE], [DATYPE], [URL], [DADESC], [FAMAT], [DASIZE], [SSMLMC], [SSMLID], [SLT], [KEYWORD], [ABSTRACT], [SCOPE], [XXFL], [ZTFL], [CKZBX], [GXZQ], [ZCR], [METANAME], [ALIANAME], [METADESC], [DWMC], [DWDZ], [LXRMC], [EMAIL], [WEBSITE], [LXDH], [FBRQ], [MINX], [MINY], [MAXX], [MAXY], [WKID], [WKT], [REQUESTMODE], [SCCS], [LLCS], [SQCS], [VERSION], [DELETED], [CREATETIME], [PIDNAME], [TYPE], [PREFIX], [ADDRESS], [ZYBM], [CROSS_TYPE], [CSJL], [APPKEY], [LUURL], [METATYPE], [FZ]) VALUES (N'4028198163684b7a0163685105b70004', N'4028198163684b7a0163685105b70004', N'服务1', null, N'0', N'http://192.168.1.62:6080/arcgis/rest/services/20170403/MapServer', N'', null, null, null, null, N'', null, null, null, null, null, null, null, N'王函', null, null, null, null, null, null, null, null, null, N'2018-05-15 08:00:00.000', null, null, null, null, null, null, N'POST', null, null, null, null, null, null, null, N'2', null, null, null, null, null, null, null, null, N'ArcGIS')
GO
GO
INSERT INTO [dbo].[SYS_RES_INFO] ([ID], [NODEID], [NAME], [MLTYPE], [DATYPE], [URL], [DADESC], [FAMAT], [DASIZE], [SSMLMC], [SSMLID], [SLT], [KEYWORD], [ABSTRACT], [SCOPE], [XXFL], [ZTFL], [CKZBX], [GXZQ], [ZCR], [METANAME], [ALIANAME], [METADESC], [DWMC], [DWDZ], [LXRMC], [EMAIL], [WEBSITE], [LXDH], [FBRQ], [MINX], [MINY], [MAXX], [MAXY], [WKID], [WKT], [REQUESTMODE], [SCCS], [LLCS], [SQCS], [VERSION], [DELETED], [CREATETIME], [PIDNAME], [TYPE], [PREFIX], [ADDRESS], [ZYBM], [CROSS_TYPE], [CSJL], [APPKEY], [LUURL], [METATYPE], [FZ]) VALUES (N'4028198163684b7a0163685136120005', N'4028198163684b7a0163685136120005', N'服务2', null, N'0', N'http://192.168.1.62:6080/arcgis/rest/services/20170514/MapServer', N'', null, null, null, null, N'', null, null, null, null, null, null, null, N'王函', null, null, null, null, null, null, null, null, null, N'2018-05-15 08:00:00.000', null, null, null, null, null, null, N'POST', null, null, null, null, null, null, null, N'2', null, null, null, null, null, null, null, null, N'ArcGIS')
GO
GO
INSERT INTO [dbo].[SYS_RES_INFO] ([ID], [NODEID], [NAME], [MLTYPE], [DATYPE], [URL], [DADESC], [FAMAT], [DASIZE], [SSMLMC], [SSMLID], [SLT], [KEYWORD], [ABSTRACT], [SCOPE], [XXFL], [ZTFL], [CKZBX], [GXZQ], [ZCR], [METANAME], [ALIANAME], [METADESC], [DWMC], [DWDZ], [LXRMC], [EMAIL], [WEBSITE], [LXDH], [FBRQ], [MINX], [MINY], [MAXX], [MAXY], [WKID], [WKT], [REQUESTMODE], [SCCS], [LLCS], [SQCS], [VERSION], [DELETED], [CREATETIME], [PIDNAME], [TYPE], [PREFIX], [ADDRESS], [ZYBM], [CROSS_TYPE], [CSJL], [APPKEY], [LUURL], [METATYPE], [FZ]) VALUES (N'402881576467fb48016468385f740000', N'402881576467fb48016468385f740000', N'abc', null, N'1', N'/', N'', null, null, null, null, N'', null, null, null, null, null, null, null, N'王函', null, null, null, null, null, null, null, null, null, N'2018-07-05 08:00:00.000', null, null, null, null, null, null, N'POST', null, null, null, null, null, null, null, N'2', null, null, null, null, null, null, null, null, N'ArcGIS')
GO
GO
INSERT INTO [dbo].[SYS_RES_INFO] ([ID], [NODEID], [NAME], [MLTYPE], [DATYPE], [URL], [DADESC], [FAMAT], [DASIZE], [SSMLMC], [SSMLID], [SLT], [KEYWORD], [ABSTRACT], [SCOPE], [XXFL], [ZTFL], [CKZBX], [GXZQ], [ZCR], [METANAME], [ALIANAME], [METADESC], [DWMC], [DWDZ], [LXRMC], [EMAIL], [WEBSITE], [LXDH], [FBRQ], [MINX], [MINY], [MAXX], [MAXY], [WKID], [WKT], [REQUESTMODE], [SCCS], [LLCS], [SQCS], [VERSION], [DELETED], [CREATETIME], [PIDNAME], [TYPE], [PREFIX], [ADDRESS], [ZYBM], [CROSS_TYPE], [CSJL], [APPKEY], [LUURL], [METATYPE], [FZ]) VALUES (N'4028819064edf9de0164eedf7d080000', N'4028819064edf9de0164eedf7d080000', N'服务3', null, N'1', N'/', N'', null, null, null, null, N'', null, null, null, null, null, null, null, N'王思', null, null, null, null, null, null, null, null, null, N'2018-07-31 08:00:00.000', null, null, null, null, null, null, N'POST', null, null, null, N'1', N'0', null, null, N'2', null, null, null, null, null, null, null, null, N'ArcGIS')
GO
GO
INSERT INTO [dbo].[SYS_RES_INFO] ([ID], [NODEID], [NAME], [MLTYPE], [DATYPE], [URL], [DADESC], [FAMAT], [DASIZE], [SSMLMC], [SSMLID], [SLT], [KEYWORD], [ABSTRACT], [SCOPE], [XXFL], [ZTFL], [CKZBX], [GXZQ], [ZCR], [METANAME], [ALIANAME], [METADESC], [DWMC], [DWDZ], [LXRMC], [EMAIL], [WEBSITE], [LXDH], [FBRQ], [MINX], [MINY], [MAXX], [MAXY], [WKID], [WKT], [REQUESTMODE], [SCCS], [LLCS], [SQCS], [VERSION], [DELETED], [CREATETIME], [PIDNAME], [TYPE], [PREFIX], [ADDRESS], [ZYBM], [CROSS_TYPE], [CSJL], [APPKEY], [LUURL], [METATYPE], [FZ]) VALUES (N'4028da6363764cca016376643bd90001', N'4028da6363764cca016376643bd90001', N'q', null, N'0', N'/', N'', null, null, null, null, N'/server/2018-05-19/a2582452-56f2-43b2-b466-aaef199feb0e_气象站.png', null, null, null, null, null, null, null, N'王思', null, null, null, null, null, null, null, null, null, N'2018-05-19 08:00:00.000', null, null, null, null, null, null, N'POST', null, null, null, N'1', N'0', null, null, N'2', null, null, null, null, null, null, null, null, N'ArcGIS')
GO
GO

-- ----------------------------
-- Table structure for SYS_ROLE
-- ----------------------------
DROP TABLE [dbo].[SYS_ROLE]
GO
CREATE TABLE [dbo].[SYS_ROLE] (
[ROLE_ID] varchar(50) NOT NULL ,
[ROLE_CODE] varchar(100) NULL ,
[ROLE_NAME] varchar(100) NULL ,
[ROLE_DESC] varchar(200) NULL ,
[CREATEUSER] varchar(50) NULL ,
[CREATETIME] datetime NULL ,
[DELETED] int NULL DEFAULT ((0)) ,
[VERSION] int NULL DEFAULT ((1)) ,
[SITE_ID] int NULL 
)


GO

-- ----------------------------
-- Records of SYS_ROLE
-- ----------------------------
INSERT INTO [dbo].[SYS_ROLE] ([ROLE_ID], [ROLE_CODE], [ROLE_NAME], [ROLE_DESC], [CREATEUSER], [CREATETIME], [DELETED], [VERSION], [SITE_ID]) VALUES (N'25ddf321-c039-40d3-9b12-ab781572a822', N'TEST_ROLE', N'查看功能角色', null, null, null, N'0', N'2', null)
GO
GO
INSERT INTO [dbo].[SYS_ROLE] ([ROLE_ID], [ROLE_CODE], [ROLE_NAME], [ROLE_DESC], [CREATEUSER], [CREATETIME], [DELETED], [VERSION], [SITE_ID]) VALUES (N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', N'SUPER_MANAGER', N'超级管理员', N'该角色拥有全部权限', null, null, N'0', N'3', null)
GO
GO
INSERT INTO [dbo].[SYS_ROLE] ([ROLE_ID], [ROLE_CODE], [ROLE_NAME], [ROLE_DESC], [CREATEUSER], [CREATETIME], [DELETED], [VERSION], [SITE_ID]) VALUES (N'615c89f44a774873b48e7f004029ca0d', N'GENERAL_MANAGER', N'一般管理员', N'拥有种植管理、基础管理', null, null, N'0', N'4', null)
GO
GO

-- ----------------------------
-- Table structure for SYS_ROLE_CONTENT
-- ----------------------------
DROP TABLE [dbo].[SYS_ROLE_CONTENT]
GO
CREATE TABLE [dbo].[SYS_ROLE_CONTENT] (
[ID] varchar(50) NOT NULL ,
[ROLE_ID] varchar(50) NULL ,
[CON_ID] varchar(50) NULL 
)


GO

-- ----------------------------
-- Records of SYS_ROLE_CONTENT
-- ----------------------------
INSERT INTO [dbo].[SYS_ROLE_CONTENT] ([ID], [ROLE_ID], [CON_ID]) VALUES (N'4028819064edf9de0164eee012a00001', N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', N'40283f816366ec35016368280e530006')
GO
GO
INSERT INTO [dbo].[SYS_ROLE_CONTENT] ([ID], [ROLE_ID], [CON_ID]) VALUES (N'4028819064edf9de0164eee012b00002', N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', N'4028819064edf9de0164eedf7d080000')
GO
GO
INSERT INTO [dbo].[SYS_ROLE_CONTENT] ([ID], [ROLE_ID], [CON_ID]) VALUES (N'4028819064edf9de0164eee012c10003', N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', N'4028198163684b7a0163685136120005')
GO
GO
INSERT INTO [dbo].[SYS_ROLE_CONTENT] ([ID], [ROLE_ID], [CON_ID]) VALUES (N'4028819064edf9de0164eee012d20004', N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', N'4028198163684b7a0163685105b70004')
GO
GO

-- ----------------------------
-- Table structure for SYS_USER
-- ----------------------------
DROP TABLE [dbo].[SYS_USER]
GO
CREATE TABLE [dbo].[SYS_USER] (
[USER_ID] varchar(50) NOT NULL ,
[USER_NAME] varchar(100) NULL ,
[USER_TYPE] varchar(20) NULL ,
[PASSWORD] varchar(100) NULL ,
[STATUS] varchar(10) NULL ,
[CREATEUSER] varchar(10) NULL ,
[CREATETIME] datetime NULL ,
[GENDER] varchar(4) NULL ,
[CARDTYPE] varchar(20) NULL ,
[CARDNO] varchar(40) NULL ,
[PARTY] varchar(20) NULL ,
[DEPARTMENT] varchar(100) NULL ,
[OADDRESS] varchar(100) NULL ,
[POSITION] varchar(10) NULL ,
[DEGREE] varchar(20) NULL ,
[EMPSTATUS] varchar(10) NULL ,
[OTEL] varchar(40) NULL ,
[MOBILENO] varchar(40) NULL ,
[QQ] varchar(50) NULL ,
[EMAIL] varchar(40) NULL ,
[WEIXIN] varchar(20) NULL ,
[HADDRESS] varchar(200) NULL ,
[REMARK] varchar(200) NULL ,
[VERSION] int NULL DEFAULT ((1)) ,
[DELETED] int NULL DEFAULT ((0)) ,
[PHOTO] varchar(100) NULL ,
[NICKNAME] varchar(100) NULL ,
[XZDWCODE] varchar(100) NULL 
)


GO

-- ----------------------------
-- Records of SYS_USER
-- ----------------------------
INSERT INTO [dbo].[SYS_USER] ([USER_ID], [USER_NAME], [USER_TYPE], [PASSWORD], [STATUS], [CREATEUSER], [CREATETIME], [GENDER], [CARDTYPE], [CARDNO], [PARTY], [DEPARTMENT], [OADDRESS], [POSITION], [DEGREE], [EMPSTATUS], [OTEL], [MOBILENO], [QQ], [EMAIL], [WEIXIN], [HADDRESS], [REMARK], [VERSION], [DELETED], [PHOTO], [NICKNAME], [XZDWCODE]) VALUES (N'36fafa1a-21db-4aee-836b-39dbbb0bc4ee', N'lsf', null, N'4784a32b2b41a15e3c9753c01ab8bf11', N'1', null, null, null, null, null, null, N'中农信达', null, null, null, null, null, N'111111111111', null, null, null, null, null, null, N'0', null, N'凌树峰', null)
GO
GO
INSERT INTO [dbo].[SYS_USER] ([USER_ID], [USER_NAME], [USER_TYPE], [PASSWORD], [STATUS], [CREATEUSER], [CREATETIME], [GENDER], [CARDTYPE], [CARDNO], [PARTY], [DEPARTMENT], [OADDRESS], [POSITION], [DEGREE], [EMPSTATUS], [OTEL], [MOBILENO], [QQ], [EMAIL], [WEIXIN], [HADDRESS], [REMARK], [VERSION], [DELETED], [PHOTO], [NICKNAME], [XZDWCODE]) VALUES (N'64b33c6d-dfa3-40dd-bf53-9ef6c0e370a5', N'wh', null, N'9483f1cdfaaff2562dd9185254cfb4f5', N'1', null, N'2018-05-15 09:10:36.913', null, null, null, null, N'中农信达', null, null, null, null, null, N'111111', null, null, null, null, null, N'1', N'0', null, N'王函', null)
GO
GO
INSERT INTO [dbo].[SYS_USER] ([USER_ID], [USER_NAME], [USER_TYPE], [PASSWORD], [STATUS], [CREATEUSER], [CREATETIME], [GENDER], [CARDTYPE], [CARDNO], [PARTY], [DEPARTMENT], [OADDRESS], [POSITION], [DEGREE], [EMPSTATUS], [OTEL], [MOBILENO], [QQ], [EMAIL], [WEIXIN], [HADDRESS], [REMARK], [VERSION], [DELETED], [PHOTO], [NICKNAME], [XZDWCODE]) VALUES (N'd488ae4b-1954-4963-b3df-03fca79fd285', N'zy', null, N'a8ea4e884fe9c8116526c1f6abbffc4c', N'1', null, null, null, null, null, null, N'中农信达', null, null, null, null, null, N'111111111', null, null, null, null, null, null, N'0', null, N'张洋', null)
GO
GO
INSERT INTO [dbo].[SYS_USER] ([USER_ID], [USER_NAME], [USER_TYPE], [PASSWORD], [STATUS], [CREATEUSER], [CREATETIME], [GENDER], [CARDTYPE], [CARDNO], [PARTY], [DEPARTMENT], [OADDRESS], [POSITION], [DEGREE], [EMPSTATUS], [OTEL], [MOBILENO], [QQ], [EMAIL], [WEIXIN], [HADDRESS], [REMARK], [VERSION], [DELETED], [PHOTO], [NICKNAME], [XZDWCODE]) VALUES (N'e9599d44-3345-4761-b964-c01afd8031bb', N'lipei', null, N'400e21b4940560285afff5fd4acc23dd', N'1', null, N'2018-07-10 17:06:10.383', null, null, null, null, N'中农信达', null, null, null, null, null, N'15911111111', null, null, null, null, null, N'1', N'0', null, N'李培', null)
GO
GO
INSERT INTO [dbo].[SYS_USER] ([USER_ID], [USER_NAME], [USER_TYPE], [PASSWORD], [STATUS], [CREATEUSER], [CREATETIME], [GENDER], [CARDTYPE], [CARDNO], [PARTY], [DEPARTMENT], [OADDRESS], [POSITION], [DEGREE], [EMPSTATUS], [OTEL], [MOBILENO], [QQ], [EMAIL], [WEIXIN], [HADDRESS], [REMARK], [VERSION], [DELETED], [PHOTO], [NICKNAME], [XZDWCODE]) VALUES (N'ed89972a-670f-4701-b99e-4d784086a2ad', N'ws', null, N'e6aa57750ecfc2ecb3e1c72a763fbe95', N'1', null, N'2018-05-17 13:14:09.237', null, null, null, null, N'农科院遥感所', null, null, null, null, null, N'15680001190', null, null, null, null, null, N'1', N'0', null, N'王思', null)
GO
GO

-- ----------------------------
-- Table structure for SYS_USER_ROLE_R
-- ----------------------------
DROP TABLE [dbo].[SYS_USER_ROLE_R]
GO
CREATE TABLE [dbo].[SYS_USER_ROLE_R] (
[ID] varchar(50) NOT NULL ,
[ROLE_ID] varchar(50) NULL ,
[USER_ID] varchar(50) NULL ,
[VERSION] int NULL DEFAULT ((1)) ,
[CREATETIME] datetime NULL ,
[DELETED] varchar(20) NULL DEFAULT ((0)) 
)


GO

-- ----------------------------
-- Records of SYS_USER_ROLE_R
-- ----------------------------
INSERT INTO [dbo].[SYS_USER_ROLE_R] ([ID], [ROLE_ID], [USER_ID], [VERSION], [CREATETIME], [DELETED]) VALUES (N'402819816363a69a016363b5c05c0031', N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', N'64b33c6d-dfa3-40dd-bf53-9ef6c0e370a5', N'1', N'2018-05-15 00:00:00.000', N'0')
GO
GO
INSERT INTO [dbo].[SYS_USER_ROLE_R] ([ID], [ROLE_ID], [USER_ID], [VERSION], [CREATETIME], [DELETED]) VALUES (N'40281981636bd59001636ca3ba020001', N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', N'd488ae4b-1954-4963-b3df-03fca79fd285', N'1', N'2018-05-17 00:00:00.000', N'0')
GO
GO
INSERT INTO [dbo].[SYS_USER_ROLE_R] ([ID], [ROLE_ID], [USER_ID], [VERSION], [CREATETIME], [DELETED]) VALUES (N'40282d816361eb0e01636245f4030001', N'615c89f44a774873b48e7f004029ca0d', N'62219617ee63400b9b064ddbadafa8c1', N'1', N'2018-05-15 00:00:00.000', N'0')
GO
GO
INSERT INTO [dbo].[SYS_USER_ROLE_R] ([ID], [ROLE_ID], [USER_ID], [VERSION], [CREATETIME], [DELETED]) VALUES (N'40282d816370a4180163724ce8f70013', N'25ddf321-c039-40d3-9b12-ab781572a822', N'36fafa1a-21db-4aee-836b-39dbbb0bc4ee', N'1', N'2018-05-18 05:10:33.063', N'0')
GO
GO
INSERT INTO [dbo].[SYS_USER_ROLE_R] ([ID], [ROLE_ID], [USER_ID], [VERSION], [CREATETIME], [DELETED]) VALUES (N'402881376481b32c0164837ce6580000', N'25ddf321-c039-40d3-9b12-ab781572a822', N'e9599d44-3345-4761-b964-c01afd8031bb', N'1', N'2018-07-10 17:19:18.063', N'0')
GO
GO
INSERT INTO [dbo].[SYS_USER_ROLE_R] ([ID], [ROLE_ID], [USER_ID], [VERSION], [CREATETIME], [DELETED]) VALUES (N'402881376481b32c0164837ce6600001', N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', N'e9599d44-3345-4761-b964-c01afd8031bb', N'1', N'2018-07-10 17:19:18.110', N'0')
GO
GO
INSERT INTO [dbo].[SYS_USER_ROLE_R] ([ID], [ROLE_ID], [USER_ID], [VERSION], [CREATETIME], [DELETED]) VALUES (N'402881376481b32c0164837ce6680002', N'615c89f44a774873b48e7f004029ca0d', N'e9599d44-3345-4761-b964-c01afd8031bb', N'1', N'2018-07-10 17:19:18.117', N'0')
GO
GO
INSERT INTO [dbo].[SYS_USER_ROLE_R] ([ID], [ROLE_ID], [USER_ID], [VERSION], [CREATETIME], [DELETED]) VALUES (N'4028da63636b78bf01636c86be210002', N'2fb87947-cafd-4805-b4d3-cffd46ea48e5', N'ed89972a-670f-4701-b99e-4d784086a2ad', N'1', N'2018-05-17 00:00:00.000', N'0')
GO
GO

-- ----------------------------
-- Indexes structure for table SYS_FUNC
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table SYS_FUNC
-- ----------------------------
ALTER TABLE [dbo].[SYS_FUNC] ADD PRIMARY KEY ([ID])
GO

-- ----------------------------
-- Indexes structure for table SYS_FUNC_ROLE_R
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table SYS_FUNC_ROLE_R
-- ----------------------------
ALTER TABLE [dbo].[SYS_FUNC_ROLE_R] ADD PRIMARY KEY ([ID])
GO

-- ----------------------------
-- Indexes structure for table SYS_RES_CONTENT
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table SYS_RES_CONTENT
-- ----------------------------
ALTER TABLE [dbo].[SYS_RES_CONTENT] ADD PRIMARY KEY ([ID])
GO

-- ----------------------------
-- Indexes structure for table SYS_RES_INFO
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table SYS_RES_INFO
-- ----------------------------
ALTER TABLE [dbo].[SYS_RES_INFO] ADD PRIMARY KEY ([ID])
GO

-- ----------------------------
-- Indexes structure for table SYS_ROLE
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table SYS_ROLE
-- ----------------------------
ALTER TABLE [dbo].[SYS_ROLE] ADD PRIMARY KEY ([ROLE_ID])
GO

-- ----------------------------
-- Indexes structure for table SYS_ROLE_CONTENT
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table SYS_ROLE_CONTENT
-- ----------------------------
ALTER TABLE [dbo].[SYS_ROLE_CONTENT] ADD PRIMARY KEY ([ID])
GO

-- ----------------------------
-- Indexes structure for table SYS_USER
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table SYS_USER
-- ----------------------------
ALTER TABLE [dbo].[SYS_USER] ADD PRIMARY KEY ([USER_ID])
GO

-- ----------------------------
-- Uniques structure for table SYS_USER
-- ----------------------------
ALTER TABLE [dbo].[SYS_USER] ADD UNIQUE ([USER_NAME] ASC)
GO

-- ----------------------------
-- Indexes structure for table SYS_USER_ROLE_R
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table SYS_USER_ROLE_R
-- ----------------------------
ALTER TABLE [dbo].[SYS_USER_ROLE_R] ADD PRIMARY KEY ([ID])
GO
